Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata. SQL is a powerful language for querying and manipulating data, but it's tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you're an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference.Essential SQLAlchemy includes several sections: SQLAlchemy Core: Provide database services to your applications in a Pythonic way with the SQL Expression Language SQLAlchemy ORM: Use the object relational mapper to bind database schema and operations to data objects in your application Alembic: Use this lightweight database migration tool to handle changes to the database as your application evolves Cookbook: Learn how to use SQLAlchemy with web frameworks like Flask and libraries like SQLAcodegen

Whether you're building a social media site or an internal-use enterprise application, this hands-on guide shows you the connection between MongoDB and the business problems it's designed to solve. You'll learn how to apply MongoDB design patterns to several challenging domains, such as ecommerce, content management, and online gaming. Using Python and JavaScript code examples, you'll discover how MongoDB lets you scale your data model while simplifying the development process.

Many businesses launch NoSQL databases without understanding the techniques for using their features most effectively. This book demonstrates the benefits of document embedding, polymorphic schemas, and other MongoDB patterns for tackling specific big data use cases, including: Operational intelligence: Perform real-time analytics of business dataEcommerce: Use MongoDB as a product catalog master or inventory management systemContent management: Learn methods for storing content nodes, binary assets, and discussionsOnline advertising networks: Apply techniques for frequency capping ad impressions, and keyword targeting and biddingSocial networking: Learn how to store a complex social graph, modeled after Google+Online gaming: Provide concurrent access to character and world data for a multiplayer role-playing game

A growing community of scientists, land-management decision makers, and cavers are concerned about the protection of natural resources and want to share research among themselves. But few of them are fluent in each discipline's jargon, and cavers and geologists in particular who want to share their discoveries find it difficult to understand each other. Sandra Poucher and Rick Copeland have created this comprehensive karst glossary to correct discrepancies in communications among geologists and biologists, hydrologists and divers, cavers and speleologists, thereby enabling researchers to speak a common language. Cavers and cave divers are passionate about mastering the language to communicate their finds and understand the research of others. Speleologists (cave scientists) are eager to understand and apply cavers' discoveries to their work in the geology, biology, water flow, and other scientific aspects of caves. This multidisciplinary volume, featuring extensive reference materials, is the only one to focus on Floridian and Caribbean karst features. The highly focused result of a dynamic team of scientists, cavers, and cave divers who have sorted through the myriad of terms and definitions, this glossary is essential to geologists, hydrologists, biologists, hydrogeologists, and private businesses dealing with the study of groundwater, karst and/or treatment of sinkholes, land-management decision makers, and speleologists.